from django.db import models
from django.contrib.auth.models import AbstractUser

# Create your models here.
# class user(models.Model):
#     username = models.CharField(max_length = 20,unique = True)
#     password = models.CharField(max_length = 20)
#     mobile = models.CharField(max_length = 11,unique = True)

# 基于Django提供的用户模型进行自定义模型重写,
# 不用继承 models.Model,因为AbstractUser父类AbstractBaseUser继承了models.Model
# AbstractUer 已经存在username和passw字段,不用重新定义,只需定义mobile
class User(AbstractUser):
    mobile = models.CharField(max_length = 11,unique = True)
    #邮箱激活状态
    email_active = models.BooleanField(default = False,verbose_name = '邮箱验证状态')
    default_address = models.ForeignKey('Address', related_name = 'users', null = True, blank = True,on_delete = models.SET_NULL, verbose_name = '默认地址')

    # 声明数据库表名
    class Meta:
        db_table = 'tb_users'
        verbose_name = '用户管理'
        verbose_name_plural = verbose_name

    # 定义每个数据对象的显示信息,二不是显示 "object"
    def __str__(self):
        return self.username

from utils.models import BaseModel
#  地址模型表
class Address(BaseModel):
    """用户地址"""
    user = models.ForeignKey(User, on_delete=models.CASCADE, related_name='addresses', verbose_name='用户')
    title = models.CharField(max_length=20, verbose_name='地址名称')
    receiver = models.CharField(max_length=20, verbose_name='收货人')
    # PROTECT 当前字段受保护 不允许删除
    province = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='province_addresses', verbose_name='省')
    city = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='city_addresses', verbose_name='市')
    district = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='district_addresses', verbose_name='区')
    place = models.CharField(max_length=50, verbose_name='地址')
    mobile = models.CharField(max_length=11, verbose_name='手机')
    tel = models.CharField(max_length=20, null=True, blank=True, default='', verbose_name='固定电话')
    email = models.CharField(max_length=30, null=True, blank=True, default='', verbose_name='电子邮箱')
    is_deleted = models.BooleanField(default=False, verbose_name='逻辑删除')

    class Meta:
        db_table = 'tb_address'
        verbose_name = '用户地址'
        verbose_name_plural = verbose_name
        ordering = ['-update_time']